“Most good programmers do programming not because they expect to get paid or get adulation by the public, but because it is fun to program.”- Linus Torvalds
yum安装mysql
从yum安装,参考https://dev.mysql.com/doc/mys...
1.先添加mysql的yum库下载mysql57-community-release-el7-11.noarch.rpm,地址https://dev.mysql.com/downloa...
2.安装mysql的yum库
sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
3.查看mysql的yun库
yum repolist all | grep mysql
4.启动mysql6
shell> sudo yum-config-manager --disable mysql57-community
shell> sudo yum-config-manager --enable mysql56-community
如果提示yum-config-manager命令不存在,则可以直接修改文件/etc/yum.repos.d/mysql-community.repo,把mysql56-community的enabled置为1,mysql57-community的enabled置为0
vim mysql-community.repo
#启动使用MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
5.安装mysql
sudo yum install mysql-community-server
6.启动mysql
sudo service mysqld start
7.初始化mysql(可以设置root密码等)
mysql_secure_installation
8.登录mysql
mysql -uroot -p
mysql常用命令(用root用户登录)
查看数据库有哪些用户
SELECT User, Host, Password FROM mysql.user;
创建一个数据库名为"mydb_name"
create database mydb_name default character set utf8;
创建用户"jevoncode",任意域名都能登录,密码为jevoncodepassword
create user 'jevoncode'@'%' identified by 'jevoncodepassword';
授权mydb_name数据的所有权限给jevoncode用户
grant all privileges on mydb_name.* to 'jevoncode'@'%';
刷新数据库权限
flush privileges;
查看用户的权限
show grants for jevoncode@'%';
常见问题
查看3306端口是否监听,执行命令后没有返回消息,则没有监听此端口
netstat -tunpl |grep 3306
查看防火墙是否允许访问,执行命令后没有返回消息能用则表明不能方位该端口
iptables -L -n|grep 3306
设置防火墙允许访问端口3306
iptables -I INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
保存防火墙策略
iptables-save > iptables.rules
中文乱码时,用这命令SHOW VARIABLES LIKE 'char%';查看mysql-server的编码
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
mysql默认server编码为latin1,所以设置为utf8,修改/etc/my.cnf,在[mysqld]下添加:
[mysqld]
character-set-server=utf8
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用
。你还可以使用@
来通知其他用户。